[dbo].[AsiNrdsOfficeSupplemental]

Property	Value
Created	3:53:49 PM Tuesday, November 22, 2011
Last Modified	11:40:00 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_AsiNrdsOfficeSupplemental: ID\SEQN$	ID	varchar(10)	10	('')
$Cluster Primary Key PK_AsiNrdsOfficeSupplemental: ID\SEQN$	SEQN	int	4	('')
	AssociationId	varchar(4)	4	('')
	NMSalespersonCount	varchar(5)	5	('')
	OfficeId	varchar(9)	9	('')
	Status	varchar(1)	1	('')
	StatusDate	datetime	8
	NARTimestamp	varchar(20)	20	('')
	TIME_STAMP	timestamp	8

	Name	Columns	Unique
$Cluster Primary Key PK_AsiNrdsOfficeSupplemental: ID\SEQN$	PK_AsiNrdsOfficeSupplemental	ID, SEQN

SQL Script

CREATE TABLE [dbo].[AsiNrdsOfficeSupplemental]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_ID] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_SEQN] DEFAULT (''),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_AssociationId] DEFAULT (''),
[NMSalespersonCount] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdOfficeSupplementals_NMSalespersonCount] DEFAULT (''),
[OfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_OfficeId] DEFAULT (''),
[Status] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_Status] DEFAULT (''),
[StatusDate] [datetime] NULL,
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOfficeSupplemental_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsOfficeSupplemental] ADD CONSTRAINT [PK_AsiNrdsOfficeSupplemental] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO